<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page language="java" import="java.util.*"%>
<%@page language="java" import="com.base.myproject.client.jdbc.*"%>
<%@page language="java" import="com.base.myproject.server.*"%>
<%@page language="java" import="com.base.myproject.client.jdbc.DataSet"%>
<%@page language="java" import="com.base.myproject.server.tools.*"%>
<%@page language="java"
	import="com.base.myproject.server.GreetingServiceImpl"%>
<%@page language="java"
	import="com.base.myproject.client.busi.service.Associator"%>  
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<style type="text/css">
<!--
body{
	font-size: 20px;  /*打印字体大小调整*/
	text-align: center;
}
.STYLE3 {font-size: x-large;height:1.3cm }
table {
	margin-bottom: 50px;
	width:100%;
	text-align: center;
}
.margin_botton100 {
	margin-bottom: 200px;
}
-->
</style>
<%
	String icode = request.getParameter("icode");
	DataSetTool DST = new DataSetTool();
	String sql = "select bookName,brwDate,backDate,datediff(d, lastDate, backDate) as finesDate, fines from hr_book a, hr_borrow b where a.bookNo = b.bookNo and b.icode = " + icode;
	DataSet ds = DST.getDataSet(sql);
	String bookName = "",brwDate = " ",backDate = " ",finesDate = " ",fines = " ";
	
	bookName = ds.getValue(0, "bookName");
	brwDate = ds.getValue(0, "brwDate").substring(0, 10);
	backDate = ds.getValue(0, "backDate").substring(0, 10);
	finesDate = ds.getValue(0, "finesDate");
	fines = ds.getValue(0, "fines");
%>
</head>

<body>
<h3>图书罚款明细</h3>

<table border="1">
  <tr class="STYLE3">
  	<td>图书名</td>
  	<td>借出日期</td>
  	<td>归还日期</td>
  	<td>逾期天数</td>
  	<td>罚款金额</td>
  </tr>
  
  <tr>
  	<td><%= bookName %></td>
  	<td><%= brwDate %></td>
  	<td><%= backDate %></td>
  	<td><%= finesDate %></td>
  	<td><%= fines %></td>
  </tr>
</table>
<div align="right">员工签名:_____________		人事部签名:______________</div>
<div class="margin_botton100"></div>
<h3>图书罚款明细</h3>

<table border="1">
  <tr class="STYLE3">
  	<td>图书名</td>
  	<td>借出日期</td>
  	<td>归还日期</td>
  	<td>逾期天数</td>
  	<td>罚款金额</td>
  </tr>
  
  <tr>
  	<td><%= bookName %></td>
  	<td><%= brwDate %></td>
  	<td><%= backDate %></td>
  	<td><%= finesDate %></td>
  	<td><%= fines %></td>
  </tr>
</table>
<div align="right">员工签名:_____________		人事部签名:______________</div>
</body>
</html>
